FO_INS_Policy_Messages

This table contains definitions of insurance and policy specific messages.

The insevalpolmsg permission must be assigned to enable this functionality. The message will display as the user exits the policy number field in the application if the insurance code and content of the policy number matches the definitions.

There can be more than one message per insurance.

If multiple values need to be compared with an “OR” statement for one insurance code, then more than one record should be created for the same insurance code. Each record will be evaluated separately and if the condition matches then that message will be displayed. When more than one message applies, the messages to display will be combined together into one message prompt.

 

Field Type Notes

Ins_PolMsg_ID

bigint

ID field, a counter. Unique

InsCode

varchar(50)

Insurance code.

Enter a valid insurance code.

PolicyContainsText

varchar(50)

String(s) of text to be search for in the policy number.

This is a ‘policy number contains’ search.

Multidimensional pipe delimited value, with leading and trailing pipes.

Enter the search strings, separated by pipes.

For this message to display, every search string must be present.

IE: |an|455|

Policy AN123455 will show message

Policy AN454123 will not show message

UserMessage

varchar(255)

Enter the message to display if all pipe delimited strings from PolicyContainsText field above are present in the policy number.

CreateDate

datetime

Date record was created.

Informational

CreateUser

varchar(50)

User who created record.

Informational

EditDate

datetime

Date record was last edited.

Informational

EditUser

varchar(50)

User who last edited record.

Informational